The SQL Query Builder is a product of Base Now
Interface
SQL Query Builder features a textual notation to write and see the SQL code; a graphical notation of the different views, tables and query relationsships between them; and a dedicated graphical user interface to describe the query.
Visual interface to design queries & Create joins with drag and drop
Easily specify which fields you want in your query by selecting them with a checkbox next to field name. SQL Query Builder will also create joins between tables with relationships in the database. You can also create your own joins by dragging a field from one table to another field.
The Grid pane to specify criteria & Automatic field formatting
Use the grid to specify criteria, sort types, aliases, etc. SQL Query Builder will even format the fields automatically, e.g.:
You enter this: SQL Query Builder re-formats like this:
>=1-1-00 and <=31-1-00 >=#01/01/2000# AND <= #31/01/2000#
s* LIKE 's%'
Automatic SQL Statement generation
SQL Query Builder will generate the SQL Statement as you design your query.
